{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["6R UI","6R Option Weights","6R Wheels","Base Weights condensed","Base Weights","Recommendations"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":134,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"6R UI","index":0,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":false,"merged":[[7,4,7,6],[8,4,8,6],[17,4,17,6],[17,8,17,10],[18,4,18,6],[18,8,18,10],[30,2,30,10],[19,4,19,6],[20,4,20,6],[21,4,21,6],[22,4,22,6],[24,2,24,4],[24,6,24,10]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Type your name:",null,"Name of analysis:",null,null,null,"Model:",null,"Transmission:"]
[null,null,null,null,null,null,null,null,"6215R",null,"PowrQuad"]
[null,null,null,null,null,null,null,null,{"$f":"INDEX(model_6_w,MATCH(I9,model_6,0))","v":0},null,{"$f":"INDEX(IF(M47=\"S\",tran_6S_w,IF(M47=\"M\",tran_6M_w,tran_6L_w)),MATCH(K9,tran_6,0))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"INDEX(model_6_s,MATCH(I9,model_6,0))","v":0.38},null,{"$f":"INDEX(IF(M47=\"S\",tran_6S_s,IF(M47=\"M\",tran_6M_s,tran_6L_s)),MATCH(K9,tran_6,0))","v":0.375}]
[]
[null,null,"Front axle:",null,"Front hitch:",null,"Front PTO:",null,"Loader ready:",null,"Fuel level:"]
[null,null,"MFWD",null,"Not Included",null,"Not Included",null,"No",null,"Half"]
[null,null,{"$f":"INDEX(IF(M47=\"S\",FA_6S_w,IF(M47=\"M\",FA_6M_w,FA_6L_w)),MATCH(C14,FA_6,0))","v":6700},null,{"$f":"INDEX(hitch_6_w,MATCH(E14,hitch_6,0))","v":0},null,{"$f":"INDEX(PTO_6_w,MATCH(G14,PTO_6,0))","v":0},null,{"$f":"INDEX(IF(M47=\"S\",loader_6S_w,loader_6M_w),MATCH(I14,loader_6,0))","v":0},null,{"$f":"INDEX(IF(M47=\"S\",fuel_6S_w,IF(M47=\"M\",fuel_6M_w,fuel_6L_w)),MATCH(K14,fuel_6,0))","v":151.1}]
[null,null,{"$f":"INDEX(IF(M47=\"S\",FA_6S_s,IF(M47=\"M\",FA_6M_s,FA_6L_s)),MATCH(C14,FA_6,0))","v":0.375},null,{"$f":"INDEX(IF(M47=\"S\",hitch_6S_s,IF(M47=\"M\",hitch_6M_s,hitch_6L_s)),MATCH(E14,hitch_6,0))","v":1.2250000000000001},null,{"$f":"INDEX(IF(M47=\"S\",PTO_6S_s,IF(M47=\"M\",PTO_6M_s,PTO_6L_s)),MATCH(G14,PTO_6,0))","v":1},null,{"$f":"INDEX(IF(M47=\"S\",loader_6S_s,IF(M47=\"M\",loader_6M_s,loader_6L_s)),MATCH(I14,loader_6,0))","v":0.69428571428571428},null,{"$f":"INDEX(IF(M47=\"S\",fuel_6S_s,IF(M47=\"M\",fuel_6M_s,fuel_6L_s)),MATCH(K14,fuel_6,0))","v":0.26785714285714285}]
[]
[null,null,null,null,"Front wheels & tires",null,null,null,"Rear wheels & tires"]
[null,null,null,null,"Group 42",null,null,null,"Group 47"]
[null,null,null,null,"Single:",null,null,null,"Single:",null,"Dual:"]
[null,null,null,null,"420/90R30",null,null,null,"480/80R46",null,"None"]
[null,null,null,null,{"$f":"IF(M47=\"S\",INDEX(FTires_6S_w,MATCH(E21,FTires_6S,0)),IF(M47=\"L\", INDEX(FTires_6L_w,MATCH(E21,FTires_6L,0)),IF(I9=\"6145R\",INDEX(FTires_6145_w,MATCH(E21,FTires_6145,0)),IF(I9=\"6155R\",INDEX(FTires_6155_w,MATCH(E21,FTires_6155,0)),0))))","v":371},null,null,null,{"$f":"IF(M47=\"S\",INDEX(RTires_6S_w,MATCH(I21,RTires_6S,0)),IF(M47=\"L\", INDEX(RTires_6L_w,MATCH(I21,RTires_6L,0)),IF(I9=\"6145R\",INDEX(RTires_6145_w,MATCH(I21,RTires_6145,0)),IF(I9=\"6155R\",INDEX(RTires_6155_w,MATCH(I21,RTires_6155,0)),0))))","v":786.4},null,{"$f":"IF(M47=\"S\",INDEX(Rduals_6S_w,MATCH(K21,Rduals_6S,0)),IF(M47=\"L\", INDEX(Rduals_6L_w,MATCH(K21,Rduals_6L,0)),IF(I9=\"6145R\",INDEX(Rduals_6145_w,MATCH(K21,Rduals_6145,0)),IF(I9=\"6155R\",INDEX(Rduals_6155_w,MATCH(K21,Rduals_6155,0)),0))))","v":0}]
[null,null,null,null,1,null,null,null,0,null,0]
[]
[null,null,"Front ballast",null,null,null,"Rear wheel weights"]
[null,null,"Weight support:",null,"Suitcase weights:",null,"55 kg:",null,"72 kg:",null,"205 kg:"]
[null,null,"Not Included",null,"None",null,"None",null,"None",null,"None"]
[null,null,{"$f":"INDEX(FWS_6_w,MATCH(C27,FWS_6,0))","v":0},null,{"$f":"INDEX(SW_6_w,MATCH(E27,SW_6,0))","v":0},null,{"$f":"INDEX(w72_6_w,MATCH(G27,w72_6,0))","v":0},null,{"$f":"INDEX(w72_6_w,MATCH(I27,w72_6,0))","v":0},null,{"$f":"INDEX(w205_6_w,MATCH(K27,w205_6,0))","v":0}]
[null,null,{"$f":"INDEX(IF(M47=\"S\",FWS_6S_s,IF(M47=\"M\",FWS_6M_s,FWS_6L_s)),MATCH(C27,FWS_6,0))","v":1.2651785714285715},null,{"$f":"INDEX(IF(M47=\"S\",SW_6S_s,IF(M47=\"M\",SW_6M_s,SW_6L_s)),MATCH(E27,SW_6,0))","v":1.3657142857142857},null,0,null,0,null,0]
[]
[null,null,"Enter any additional ballast (kg)"]
[null,null,"Front support:",null,"Front axle:",null,"Side mount:",null,"Rear Axle:",null,"Rear hitch:"]
[null,null,0,null,0,null,0,null,0,null,0]
[null,null,{"$f":"C33","v":0},null,{"$f":"E33","v":0},null,{"$f":"G33","v":0},null,{"$f":"I33","v":0},null,{"$f":"K33","v":0}]
[null,null,1.35,null,1,null,0.6,null,0,null,-0.35499999999999998]
[]
[]
[null,null,"Total weight:",null,{"$f":"C47& \" kg       \"&ROUND(C47*2.20462,0)& \" lb\"","v":"8009 kg       17657 lb"}]
[null,null,"Weight / PTO-hp (SAE):",null,{"$f":"ROUND(C47/K47,0)& \" kg/PTO-hp   \"& ROUND((C47*2.20462)/K47,0) &\" lb/PTO-hp\"","v":"46 kg/PTO-hp   100 lb/PTO-hp"}]
[null,null,"Weight / Engine power:",null,{"$f":"ROUND(C47/I47,0)& \" kg/hp          \"& ROUND((C47*2.20462)/I47,0) &\" lb/hp\"","v":"37 kg/hp          82 lb/hp"}]
[null,null,"Front axle weight:",null,{"$f":"E47&\" kg           \"&ROUND(E47*2.20462,0)& \" lb\"","v":"2924 kg           6446 lb"}]
[null,null,"Rear axle weight:",null,{"$f":"C47-E47&\" kg           \"&ROUND((C47-E47)*2.20462,0)& \" lb\"","v":"5085 kg           11210 lb"},null,{"$f":"G47","v":0.36499999999999999},null,{"$f":"100%-G42","v":0.63500000000000001},null,{"$f":"TODAY()","v":"2015-10-12"}]
[]
[]
[]
[null,null,"Total weight (kg)",null,"Front axle (kg)",null,"Front split (%)",null,"HP",null,"PTO HP",null,"Frame Size"]
[null,null,{"$f":"ROUND(SUM(I10,K10,C15,E15,G15,I15,K15,E22,I22,K22,C28,E28,G28,I28,K28,C34,E34,G34,I34,K34),0)","v":8009},null,{"$f":"ROUND(SUM(I10*I11,K10*K11,C15*C16,E15*E16,G15*G16,I15*I16,K15*K16,E22*E23,I22*I23,K22*K23,C28*C29,E28*E29,G28*G29,I28*I29,K28*K29,C34*C35,E34*E35,G34*G35,I34*I35,K34*K35),0)","v":2924},null,{"$f":"ROUND(E47/C47,3)","v":0.36499999999999999},null,{"$f":"INDEX(hp_6,MATCH(I9,model_6,0))","v":215},null,{"$f":"INDEX(PTOhp_6,MATCH(I9,model_6,0))","v":176},null,{"$f":"INDEX(frame_6,MATCH(I9,model_6,0))","v":"L"}]

{"sheet":"6R Option Weights","index":1,"n_rows":70,"n_cols":17,"rows_kept":70,"cut":false,"hidden":true,"merged":[[2,6,2,7],[14,1,14,2],[14,3,14,4],[14,5,14,6]]}
[]
[]
[null,null,null,null,null,null,"Wheelbase (mm)"]
["Model","kg total","% front axle","hp","PTO-hp","Frame size","2WD","MFWD/TLS",null,null,null,null,"kg total","% front axle","No split data provided by Christian"]
["6110R",0,0.38,110,86,"S",2580,2580,null,null,null,null,4481.5,0.4]
["6120R",0,0.38,120,94,"S",2580,2580,null,null,null,null,4481.5,0.4]
["6130R",0,0.38,130,101,"S",2580,2580,null,null,null,null,4481.5,0.4]
["6145R",0,0.38,145,111,"M",2985,2765,"using MFWD/TLS wheelbase",null,null,null,5531.5,0.4]
["6155R",0,0.38,155,121,"M",2985,2765,"2WD is < 2% take rate",null,null,null,5531.5,0.4]
["6175R",0,0.38,175,140,"L",null,2800,null,null,null,null,5981.5,0.4]
["6195R",0,0.38,195,158,"L",null,2800,null,null,null,null,5981.5,0.4]
["6215R",0,0.38,215,176,"L",null,2800,null,null,null,null,5981.5,0.4]
[]
[]
[null,"Small",null,"Mid",null,"Large"]
[null,"kg total","% front axle","kg total","% front axle","kg total","% front axle","notes /compatibility "]
["Transmission"]
["PowrQuad",0,0.38,0,0.38,0,0.375]
["AutoQuad",0,0.38,0,0.38,0,0.375]
["IVT",600,0.38,350,0.38,350,0.375]
["DirectDrive",0,0.38,300,0.38,300,0.375]
[]
["Front Axle"]
["2WD",3890,0.34,5390,0.33]
["MFWD",4400,0.38,6000,0.38,6700,0.375]
["TLS",4470,0.38,6050,0.38,6770,0.375,"offered with or without front brakes"]
["TLS w/ front brakes",4500,0.38,6083,0.38,6800,0.375]
[]
["Front 3-Point Hitch",null,"Small %","Mid %","Large %",null,null,null,null,null,null,null,null,null,null,"mm from FA"]
["Not Included",0,{"$f":"($H$5+630)/$H$5","v":1.2441860465116279},{"$f":"($H$8+630)/$H$8","v":1.2278481012658229},{"$f":"($H$10+630)/$H$10","v":1.2250000000000001},null,null,"Front hitch not compatible with 2WD",null,null,null,null,null,"Cat. 3",213,630]
["Economy",213,{"$f":"($H$5+630)/$H$5","v":1.2441860465116279},{"$f":"($H$8+630)/$H$8","v":1.2278481012658229},{"$f":"($H$10+630)/$H$10","v":1.2250000000000001},null,null,"Check for weight difference between economy and premium options",null,null,null,null,null,"Premium",220,630]
["Premium",220,{"$f":"($H$5+630)/$H$5","v":1.2441860465116279},{"$f":"($H$8+630)/$H$8","v":1.2278481012658229},{"$f":"($H$10+630)/$H$10","v":1.2250000000000001},null,null,null,null,null,null,null,null,"confirm these include front SCVs, etc "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"why is this distance (630 mm) not different from mid and large frame like the suitcase weights?"]
["Front PTO",null,"Small %","Mid %","Large %"]
["Not Included",0,1,1,1,null,null,"small also offers aux drive prep",null,null,null,null,null,null,null,"mm from FA"]
["Included",65,{"$f":"($H$5+574)/$H$5","v":1.2224806201550387},{"$f":"($H$8+574)/$H$8","v":1.2075949367088608},{"$f":"($H$10+574)/$H$10","v":1.2050000000000001},null,null,null,null,null,null,null,null,null,65,574]
[]
["Fuel level",null,null,null,null,null,null,"Diesel + DEF"]
["Empty",0,{"$f":"750/$H$5","v":0.29069767441860467},0,{"$f":"750/$H$8","v":0.27124773960216997},0,{"$f":"750/$H$10","v":0.26785714285714285},"Small: 220 L diesel at .85kg/L + 13 L DEF at 1.085 kg/L",null,null,null,null,null,"750mm distance estimated by engineering for Christian (to rear axle)"]
["Half",{"$f":"B41*0.5","v":100.55249999999999},{"$f":"750/$H$5","v":0.29069767441860467},{"$f":"D41*0.5","v":129.80500000000001},{"$f":"750/$H$8","v":0.27124773960216997},{"$f":"F41*0.5","v":151.1},{"$f":"750/$H$10","v":0.26785714285714285},"Mid: 285 L diesel at .85kg/L + 16 L DEF at 1.085 kg/L"]
["Full",{"$f":"220*(0.85)+13*(1.085)","v":201.10499999999999},0.29069767441860467,{"$f":"285*(0.85)+16*(1.085)","v":259.61},{"$f":"750/$H$8","v":0.27124773960216997},{"$f":"330*(0.85)+20*(1.085)","v":302.2},0.26785714285714285,"Large: 330 L diesel at .85kg/L + 20 L DEF at 1.085 kg/L"]
[]
["Front Weight Support",null,"Small %","Mid %","Large %"]
["Not Included",0,{"$f":"($H$5+640)/$H$5","v":1.248062015503876},{"$f":"($H$8+742.5)/$H$8","v":1.2685352622061483},{"$f":"($H$10+742.5)/$H$10","v":1.2651785714285715},null,"Code 8951, Front base weight - 110kg",null,null,null,null,null,null,null,"mm from FA"]
["Included",110,{"$f":"($H$5+640)/$H$5","v":1.248062015503876},{"$f":"($H$8+742.5)/$H$8","v":1.2685352622061483},{"$f":"($H$10+742.5)/$H$10","v":1.2651785714285715},null,"Not in combination with front hitch or front PTO",null,null,null,null,null,null,null,"S","M-L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"FWS + 0…",640,742.5]
["Front Suitcase Weights",null,"Small %","Mid %","Large %",null,null,null,null,null,null,null,null,8,860,962.5]
["None",0,{"$f":"($H$5+936)/$H$5","v":1.3627906976744186},{"$f":"($H$8+1024)/$H$8","v":1.3703435804701627},{"$f":"($H$10+1024)/$H$10","v":1.3657142857142857},null,null,null,null,null,null,null,null,10,860,962.5]
[8,{"$f":"43*A49","v":344},{"$f":"($H$5+936)/$H$5","v":1.3627906976744186},{"$f":"($H$8+1024)/$H$8","v":1.3703435804701627},{"$f":"($H$10+1024)/$H$10","v":1.3657142857142857},null,"code 8957, 400kg",null,null,null,null,null,null,12,860,962.5]
[10,{"$f":"43*A50","v":430},{"$f":"($H$5+936)/$H$5","v":1.3627906976744186},{"$f":"($H$8+1024)/$H$8","v":1.3703435804701627},{"$f":"($H$10+1024)/$H$10","v":1.3657142857142857},null,"code 8958, 500kg",null,null,null,null,null,null,14,860,962.5]
[12,516,1.3627906976744186,{"$f":"($H$8+1024)/$H$8","v":1.3703435804701627},{"$f":"($H$10+1024)/$H$10","v":1.3657142857142857},null,"code 8959, 600kg",null,null,null,null,null,null,16,879,981.5]
[14,602,1.3627906976744186,1.3703435804701627,1.3657142857142857,null,"code 8960, 700kg",null,null,null,null,null,null,18,879,981.5]
[16,688,1.3627906976744186,1.3703435804701627,1.3657142857142857,null,"code 8961, 800kg",null,"Why isn't code 8961 on configurator? (6155R)",null,null,null,null,null,936,1024,"<< average mm when removing impact of FWS"]
[18,{"$f":"43*A54","v":774},1.3627906976744186,1.3703435804701627,1.3657142857142857,null,"code 8962, 900kg",null,"Description on config: Add 2881 Lb. Front, Subtract 774 Lb. Rear."]
[]
["Rear Wheel Weights"]
["55 kg"]
["None",0,0]
["One pair",110,0]
["72 kg"]
["None",0,0,"Mid and large only"]
["One pair",144,0]
["205 kg"]
["None",0,0,"Mid and large only"]
["One pair",410,0]
["Two pairs",{"$f":"B65*2","v":820},0]
[null,null,null,null,null,null,null,null,"distance to rear axle"]
["Loader ready","Small","Small %","M/L","Mid %","Large %",null,324,1789]
["No",0,{"$f":"1789/$H$5","v":0.69341085271317826},0,{"$f":"1909/$H$8","v":0.69041591320072337},{"$f":"1944/$H$10","v":0.69428571428571428},null,426.5,1908.9]
["Yes",324,{"$f":"1789/$H$5","v":0.69341085271317826},426.5,{"$f":"1909/$H$8","v":0.69041591320072337},{"$f":"1944/$H$10","v":0.69428571428571428},null,426.5,1943.9]

{"sheet":"6R Wheels","index":2,"n_rows":115,"n_cols":14,"rows_kept":115,"cut":false,"hidden":true,"merged":[]}
[]
[null,"6110-6130R",null,null,"6145R",null,null,"6155R",null,null,"6175-6215R",null,null,"*not provided by Christian, using estimates"]
["FRONT"]
[null,"Front singles",null,null,"Front singles",null,null,"Front singles",null,null,"Front singles"]
[null,"10.00-16 (2WD)",112,null,"11.00-16 (2WD)",120,null,"11.00-16 (2WD)",120,null,"16.9R30 (420/90R30)",371]
[null,"11L-15 (2WD)",112,null,"11.00-20 (2WD)",128,null,"11.00-20 (2WD)",128,null,"320/85R38",{"$f":"INDEX(fronttires_w,MATCH(K6,fronttires,0))","v":391}]
[null,"13.6-38 (Bias)",365.6,null,"14L-16.1 (2WD)",140,null,"14L-16.1 (2WD)",140,null,"380/80R38",380]
[null,"270/80R36",275,null,"16.9R26",260,null,"16.9R28 (420/85R28)",324.60000000000002,null,"380/85R34",368]
[null,"270/95R32",275,null,"16.9R28 (420/85R28)",324.60000000000002,null,"16.9R30 (420/90R30)",371,null,"420/85R34",415]
[null,"320/85R24",{"$f":"INDEX(fronttires_w,MATCH(B10,fronttires,0))","v":185.6},null,"270/80R36",275,null,"270/95R38",325,null,"420/90R30",371]
[null,"320/85R28",{"$f":"INDEX(fronttires_w,MATCH(B11,fronttires,0))","v":217.6},null,"270/95R32",275,null,"320/85R34",{"$f":"INDEX(fronttires_w,MATCH(H11,fronttires,0))","v":317},null,"480/70R30",370.6]
[null,"340/85R24",{"$f":"INDEX(fronttires_w,MATCH(B12,fronttires,0))","v":196.8},null,"270/95R38",325,null,"320/85R38",{"$f":"INDEX(fronttires_w,MATCH(H12,fronttires,0))","v":391},null,"480/70R34",456.8]
[null,"340/85R28",{"$f":"INDEX(fronttires_w,MATCH(B13,fronttires,0))","v":244},null,"320/85R34",{"$f":"INDEX(fronttires_w,MATCH(E13,fronttires,0))","v":317},null,"380/80R38",{"$f":"INDEX(fronttires_w,MATCH(H13,fronttires,0))","v":380},null,"600/65R28",456.8]
[null,"340/85R38",325,null,"380/85R28",{"$f":"INDEX(fronttires_w,MATCH(E14,fronttires,0))","v":268.60000000000002},null,"380/85R30",309.5]
[null,"380/85R24",{"$f":"INDEX(fronttires_w,MATCH(B15,fronttires,0))","v":229.6},null,"380/85R30",309.5,null,"380/85R34",{"$f":"INDEX(fronttires_w,MATCH(H15,fronttires,0))","v":368}]
[null,"400/80R24 - special profile",244.8,null,"420/85R24",{"$f":"INDEX(fronttires_w,MATCH(E16,fronttires,0))","v":282.39999999999998},null,"420/85R28",325]
[null,"420/70R24",{"$f":"INDEX(fronttires_w,MATCH(B17,fronttires,0))","v":245.8},null,"420/85R28",324.60000000000002,null,"420/85R34",{"$f":"INDEX(fronttires_w,MATCH(H17,fronttires,0))","v":415}]
[null,"420/85R24",{"$f":"INDEX(fronttires_w,MATCH(B18,fronttires,0))","v":282.39999999999998},null,"440/80R24 - special profile",244.8,null,"420/90R30",371]
[null,"440/80R24 - special profile",298,null,"480/70R24",{"$f":"INDEX(fronttires_w,MATCH(E19,fronttires,0))","v":300.39999999999998},null,"480/70R30",370.6]
[null,"480/70R24",{"$f":"INDEX(fronttires_w,MATCH(B20,fronttires,0))","v":300.39999999999998},null,"540/65R24",{"$f":"INDEX(fronttires_w,MATCH(E20,fronttires,0))","v":311.60000000000002},null,"480/70R34",456.8]
[null,"540/65R24",{"$f":"INDEX(fronttires_w,MATCH(B21,fronttires,0))","v":311.60000000000002},null,"540/65R28",{"$f":"INDEX(fronttires_w,MATCH(E21,fronttires,0))","v":362.5},null,"540/65R28",362.5]
[null,null,null,null,null,null,null,"600/65R28",456.8]
[]
[]
[]
["REAR"]
[null,"Singles",null,null,"Singles",null,null,"Singles",null,null,"Singles"]
[null,"13.6-46 -R2",{"$f":"INDEX(reartires_w,MATCH(B28,reartires,0))","v":456},null,"14.9R46",{"$f":"INDEX(reartires_w,MATCH(E28,reartires,0))","v":528},null,"14.9R46",{"$f":"INDEX(reartires_w,MATCH(H28,reartires,0))","v":528},null,"18.4R46 (480/80R46)",786.4]
[null,"270/95R48",450,null,"18.4R42 (480/80R42)",748.2,null,"18.4R42 (480/80R42)",748.2,null,"320/90R54",{"$f":"INDEX(reartires_w,MATCH(K29,reartires,0))","v":664}]
[null,"300/95R46",500,null,"270/95R48",450,null,"18.4R46 (480/80R46)",786.4,null,"380/90R50",650]
[null,"320/90R42",{"$f":"INDEX(reartires_w,MATCH(B31,reartires,0))","v":462},null,"300/95R46",500,null,"300/95R52",600,null,"380/90R54",700]
[null,"340/85R48",500,null,"300/95R52",600,null,"320/90R50",{"$f":"INDEX(reartires_w,MATCH(H32,reartires,0))","v":600},null,"480/80R46",{"$f":"INDEX(reartires_w,MATCH(K32,reartires,0))","v":786.4}]
[null,"380/90R46",575,null,"320/90R50",{"$f":"INDEX(reartires_w,MATCH(E33,reartires,0))","v":600},null,"320/90R54",{"$f":"INDEX(reartires_w,MATCH(H33,reartires,0))","v":664},null,"480/80R50",870]
[null,"420/85R30 (16.9R30)",{"$f":"INDEX(reartires_w,MATCH(B34,reartires,0))","v":349.4},null,"380/90R46",575,null,"380/90R50",650,null,"520/85R42",750]
[null,"420/85R34",415,null,"420/80R46",732.6,null,"420/80R46",732.6,null,"520/85R46",880.8]
[null,"420/85R38",464.8,null,"460/85R38 (18.4R38)",{"$f":"INDEX(reartires_w,MATCH(E36,reartires,0))","v":553},null,"480/80R42",{"$f":"INDEX(reartires_w,MATCH(H36,reartires,0))","v":748.2},null,"620/70R42",894.6]
[null,"460/85R30 (18.4R30)",384.6,null,"480/80R38",{"$f":"INDEX(reartires_w,MATCH(E37,reartires,0))","v":556.79999999999995},null,"480/80R46",786.4,null,"650/85R38",1002]
[null,"460/85R34",468,null,"480/80R38 - special profile",556.79999999999995,null,"480/80R50",870,null,"710/70R38",991.4]
[null,"460/85R38 (18.4R38)",553,null,"480/80R42",{"$f":"INDEX(reartires_w,MATCH(E39,reartires,0))","v":748.2},null,"520/85R38",623.79999999999995,null,"710/70R42",1077.5999999999999]
[null,"480/70R38",530.4,null,"520/70R38",{"$f":"INDEX(reartires_w,MATCH(E40,reartires,0))","v":568.6},null,"520/85R42",750,null,"Duals"]
[null,"480/80R34 - special profile",476,null,"520/85R38",{"$f":"INDEX(reartires_w,MATCH(E41,reartires,0))","v":623.79999999999995},null,"620/70R42",894.6,null,"None",0]
[null,"480/80R38 - special profile",556.79999999999995,null,"600/65R38",{"$f":"INDEX(reartires_w,MATCH(E42,reartires,0))","v":623.20000000000005},null,"650/65R38",740.2,null,"18.4R46 (480/80R46)",{"$f":"L28-F53","v":736.4}]
[null,"520/70R34",{"$f":"INDEX(reartires_w,MATCH(B43,reartires,0))","v":501},null,"650/65R38",{"$f":"INDEX(reartires_w,MATCH(E43,reartires,0))","v":740.2},null,"650/85R38",1002,null,"320/90R54",{"$f":"L29-F53","v":614}]
[null,"520/70R38",{"$f":"INDEX(reartires_w,MATCH(B44,reartires,0))","v":568.6},null,"Duals",null,null,"710/70R38",991.4,null,"380/90R50",{"$f":"L30-F53","v":600}]
[null,"600/65R38",{"$f":"INDEX(reartires_w,MATCH(B45,reartires,0))","v":623.20000000000005},null,"None",0,null,"710/70R42",1077.5999999999999,null,"380/90R54",{"$f":"L31-F53","v":650}]
[null,"Duals",null,null,"14.9R46",{"$f":"F28-F53","v":478},null,"Duals",null,null,"480/80R46",{"$f":"L32-F53","v":736.4}]
[null,"None",0,null,"320/90R50",{"$f":"F33-F53","v":550},null,"None",0,null,"480/80R50",{"$f":"L33-F53","v":820}]
[null,null,null,null,"420/80R46",{"$f":"F35-F53","v":682.6},null,"14.9R46",{"$f":"I30-F53","v":736.4},null,"520/85R42",{"$f":"L34-F53","v":700}]
[null,null,null,null,"480/80R38",{"$f":"F37-F53","v":506.79999999999995},null,"18.4R46 (480/80R46)",{"$f":"I30-F53","v":736.4},null,"620/70R42",{"$f":"L36-F53","v":844.6}]
[null,null,null,null,"480/80R42",{"$f":"F39-F53","v":698.2},null,"320/90R50",{"$f":"I36-F53","v":698.2},null,"710/70R38",{"$f":"L38-F53","v":941.4}]
[null,null,null,null,null,null,null,"320/90R54",{"$f":"I33-F53","v":614}]
[null,null,null,null,"Dual data not provided",null,null,"380/90R50",{"$f":"I34-F53","v":600}]
[null,null,null,null,"Reduction for steel dual estimate:",50,null,"420/80R46",{"$f":"I35-F53","v":682.6}]
[null,null,null,null,null,null,null,"480/80R42",{"$f":"I36-F53","v":698.2}]
[null,null,null,null,null,null,null,"480/80R46",{"$f":"I37-F53","v":736.4}]
[null,null,null,null,null,null,null,"480/80R50",{"$f":"I38-F53","v":820}]
[null,null,null,null,null,null,null,"520/85R42",{"$f":"I40-F53","v":700}]
[null,null,null,null,null,null,null,"620/70R42",{"$f":"I41-F53","v":844.6}]
[null,null,null,null,null,null,null,"710/70R38",{"$f":"I44-F53","v":941.4}]
[]
[]
[]
[null,"Data provided by Christian Koetter from R2 shown below"]
[]
[null,"REAR",null,null,"FRONT"]
[null,"13.6-46 -R2",456,null,"10.00-16",112]
["single/dual","14.9R46",528,null,"11.00-16",120]
[null,"320/90R42",462,null,"11.00-20",128]
["single/dual","320/90R50",600,null,"11L-15 In. 8PR F3 Bias",112]
["single/dual","320/90R54",664,null,"13.6-38",365.6]
[null,"380/80R38",380,null,"14L-16.1",140]
["single/dual","420/80R46\n(18.4R42 In. 151A8 R1 Radial) ",732.6,null,"16.9R26",260]
[null,"420/85R30 (16.9R30)",349.4,null,"320/85R24",185.6]
[null,"420/85R34",415,null,"320/85R28",217.6]
[null,"420/85R38",464.8,null,"320/85R34",317]
[null,"460/85R30 (18.4R30)",384.6,null,"320/85R38",391]
[null,"460/85R34",468,null,"320/90R46",576]
[null,"460/85R38 (18.4R38)",553,null,"320/90R50",600]
[null,"480/70R34",456.8,null,"340/85R24",196.8]
[null,"480/70R38",530.4,null,"340/85R28",244]
[null,"480/80R34",476,null,"380/70R24",221.2]
["single/dual","480/80R38",556.79999999999995,null,"380/70R28",249.6]
["single/dual","480/80R42",748.2,null,"380/80R38",380]
["single/dual","480/80R46",786.4,null,"380/85R24",229.6]
["single/dual","480/80R50",870,null,"380/85R28",268.60000000000002]
[null,"520/70R34",501,null,"380/85R30\n(14.9R30 In. 135A8 R1 Radial) ",309.5]
[null,"520/70R38",568.6,null,"380/85R34",368]
[null,"520/85R38",623.79999999999995,null,"400/80R24",244.8]
["single/dual","520/85R42",750,null,"400/80R28",290]
[null,"520/85R46",880.8,null,"420/70R24",245.8]
[null,null,null,null,"420/70R28",281.60000000000002]
[null,"540/65R34",460,null,"420/85R24",282.39999999999998]
[null,"540/65R38",509,null,"420/85R28 (16.9R28)",324.60000000000002]
[null,"540/80R38",606,null,"420/85R30",349.4]
[null,"580/70R38",646.4,null,"420/85R34",415]
[null,"580/70R42",780,null,"420/90R30",371]
[null,"600/65R38",623.20000000000005,null,"440/65R24",259.39999999999998]
["single/dual","620/70R42",894.6,null,"440/80R24",298]
[null,"650/60R38 VF",792,null,"440/80R28",336]
[null,"650/65R38",740.2,null,"460/85R30",384.6]
[null,"650/65R42",854.4,null,"480/65R24",280.39999999999998]
[null,"650/75R38",1006.6,null,"480/65R28",315.39999999999998]
[null,"650/75R42",1072,null,"480/70R24",300.39999999999998]
[null,"650/85R38",1002,null,"480/70R28",337]
[null,"710/60R38 VF",840,null,"480/70R30",370.6]
[null,"710/60R42 VF",944,null,"480/70R34",456.8]
["single/dual","710/70R38",991.4,null,"520/60R28 VF",370]
[null,"710/70R42",1077.5999999999999,null,"540/65R24",311.60000000000002]
[null,null,null,null,"540/65R28",362.5]
[null,null,null,null,"540/65R30",393.4]
[null,null,null,null,"600/60R28 VF",458]
[null,null,null,null,"600/60R30 VF",502]
[null,null,null,null,"600/65R28",456.8]
[null,null,null,null,"600/65R30",511.4]
[null,null,null,null,"600/70R28",505.2]

{"sheet":"Base Weights condensed","index":3,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":true,"merged":[[7,0,8,0],[1,2,1,5],[1,6,1,8],[1,9,1,11],[3,0,4,0],[5,0,6,0]]}
[]
[null,null,"PowerQuad & AutoQuad",null,null,null,"IVT",null,null,"DirectDrive"]
[null,null,"2WD","MFWD","TLS","TLS w/ front brakes","MFWD","TLS","TLS w/ front brakes","MFWD","TLS","TLS w/ front brakes"]
["6110-130R","kg",null,4398.8999999999996,null,null,5034.1032720000003,5204,4981.1032720000003]
[null,"% FA",null,0.40166359771761101,null,null,0.36547189530918306,null,0.40607295242603031]
["6145-155R","kg",5389.5657920000003,6456.3892800000003,null,null,null,null,6432.9954960000005]
[null,"% FA",0.32694249666931202,0.39062342659735,null,null,null,null,0.37888871918464029]
["6175-215R","kg",null,6703.466308,null,6780.5916960000013,null,7085.3820240000005,7176.3897100000004,7096.1003320000009,6949.0286560000004]
[null,"% FA",null,0.36913562181546999,null,0.38123580181430816,null,0.37484528072923229,0.38204368961698726,0.37299822357099643,0.36978872749089431]
[]
[]
["*weights should be taken with base configurations for each model, excluding: wheels/tires, ballast, fuel",null,null,null,null,null,null,null,null,null,null,null,null,null," = no data available","<< estimating"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," = not offered"]
[null,null,"Base equipment"]
[null,null,"6110R","flanged 8 position rear axle, Cat 2/3N 4755 lb (2157 kg) rear hitch, Cat 2 1400 kg drawbar, 1-3/8 in 540/1000 rear PTO"]
[null,null,"6120R","flanged 8 position rear axle, Cat 2/3N 5582 lb (2532 kg) rear hitch, Cat 2 1400 kg drawbar, 1-3/8 in 540/1000 rear PTO"]
[null,null,"6130R","flanged 8 position rear axle, Cat 2/3N 6475 lb (2937 kg) rear hitch, Cat 2 1400 kg drawbar, 1-3/8 in 540/1000 rear PTO"]
[null,null,"6145R","92 x 2550 mm rear axle, Cat 3/3N 9193 lb (4170 kg) rear hitch, Cat 2 1400 kg drawbar, 1-3/8 in 540/1000 rear PTO "]
[null,null,"6155R","92 x 2550 mm rear axle, Cat 3/3N 9193 lb (4170 kg) rear hitch, Cat 2 1400 kg drawbar, 1-3/8 in 540/1000 rear PTO "]
[null,null,"6175R","100 x 2550 mm rear axle, Cat 3/3N 10690 lb (4850 kg) rear hitch, Cat 3 1600 kg drawbar, 1-3/8 in 540/1000 rear PTO "]
[null,null,"6195R","100 x 2550 mm rear axle, Cat 3/3N 10690 lb (4850 kg) rear hitch, Cat 3 1600 kg drawbar, 1-3/8 in 540/1000 rear PTO "]
[null,null,"6215R","100 x 2550 mm rear axle, Cat 3/3N 11990 lb (5440 kg) rear hitch, Cat 3 1600 kg drawbar, 1-3/8 in 540/1000 rear PTO "]

{"sheet":"Base Weights","index":4,"n_rows":31,"n_cols":16,"rows_kept":31,"cut":false,"hidden":true,"merged":[[1,10,1,12],[1,13,1,15],[9,0,10,0],[11,0,12,0],[13,0,14,0],[15,0,16,0],[17,0,18,0],[1,2,1,5],[1,6,1,9],[7,0,8,0],[5,0,6,0],[3,0,4,0]]}
[]
[null,null,"PowerQuad",null,null,null,"AutoQuad",null,null,null,"IVT",null,null,"DirectDrive"]
[null,null,"2WD","MFWD","TLS","TLS w/ front brakes","2WD","MFWD","TLS","TLS w/ front brakes","MFWD","TLS","TLS w/ front brakes","MFWD","TLS","TLS w/ front brakes"]
["6110R","kg"]
[null,"% FA"]
["6120R","kg"]
[null,"% FA"]
["6130R","kg"]
[null,"% FA"]
["6145R","kg"]
[null,"% FA"]
["6155R","kg"]
[null,"% FA"]
["6175R","kg"]
[null,"% FA"]
["6195R","kg"]
[null,"% FA"]
["6215R","kg"]
[null,"% FA"]
[]
["*weights should be taken with base configurations for each model, excluding: wheels/tires, ballast, fuel"]
[]
[null,null,"Base equipment"]
[null,null,"6110R","flanged 8 position rear axle, Cat 2/3N 4755 lb (2157 kg) rear hitch, Cat 2 1400 kg drawbar, 1-3/8 in 540/1000 rear PTO"]
[null,null,"6120R","flanged 8 position rear axle, Cat 2/3N 5582 lb (2532 kg) rear hitch, Cat 2 1400 kg drawbar, 1-3/8 in 540/1000 rear PTO"]
[null,null,"6130R","flanged 8 position rear axle, Cat 2/3N 6475 lb (2937 kg) rear hitch, Cat 2 1400 kg drawbar, 1-3/8 in 540/1000 rear PTO"]
[null,null,"6145R","92 x 2550 mm rear axle, Cat 3/3N 9193 lb (4170 kg) rear hitch, Cat 2 1400 kg drawbar, 1-3/8 in 540/1000 rear PTO "]
[null,null,"6155R","92 x 2550 mm rear axle, Cat 3/3N 9193 lb (4170 kg) rear hitch, Cat 2 1400 kg drawbar, 1-3/8 in 540/1000 rear PTO "]
[null,null,"6175R","100 x 2550 mm rear axle, Cat 3/3N 10690 lb (4850 kg) rear hitch, Cat 3 1600 kg drawbar, 1-3/8 in 540/1000 rear PTO "]
[null,null,"6195R","100 x 2550 mm rear axle, Cat 3/3N 10690 lb (4850 kg) rear hitch, Cat 3 1600 kg drawbar, 1-3/8 in 540/1000 rear PTO "]
[null,null,"6215R","100 x 2550 mm rear axle, Cat 3/3N 11990 lb (5440 kg) rear hitch, Cat 3 1600 kg drawbar, 1-3/8 in 540/1000 rear PTO "]

{"sheet":"Recommendations","index":5,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":true,"merged":[[2,2,2,4]]}
[]
[]
[null,null,"6145R-6215R"]
[null,null,"Light","Medium","Heavy"]
[null,null,"8.7 km/h (5.4 mph) and faster","7.2-8.7 km/h \n(4.5-5.4 mph)","7.2 km/h (4.5 mph) \nand slower"]
[null,"kg/hp",46,50,56]
[null,"lb/hp",100,110,125]